package com.yxy.model;


import lombok.Data;
import tk.mybatis.mapper.annotation.KeySql;
import tk.mybatis.mapper.code.ORDER;

import java.util.Date;
import java.math.BigDecimal;

import javax.persistence.*;


@Data
@Entity
@Table(name = "table_member",schema = "")
public class TableMember {

  //用户id
  @Id
  @KeySql(useGeneratedKeys = true,sql = "SELECT @@IDENTITY",order = ORDER.AFTER)
  @Column(name = "id")
  private Long id;

  //会员编号
  @Column(name = "member_code")
  private String memberCode;

  //会员类型
  @Column(name = "member_type")
  private String memberType;

  //会员特权
  @Column(name = "member_privilege")
  private String memberPrivilege;


  //会员最高消费
  @Column(name = "max_price")
  private BigDecimal maxPrice;

  //会员最低消费
  @Column(name = "min_price")
  private BigDecimal minPrice;

  //升级最小月份
  @Column(name = "min_month")
  private String minMonth;

  //升级最大月份
  @Column(name = "max_month")
  private String maxMonth;

  //标记数据状态 0 不显示 1显示
  @Column(name = "status")
  private Long status;

  //数据备注
  @Column(name = "misc")
  private String misc;

  //创建者id
  @Column(name = "create_user_id")
  private Long createUserId;

  //创建人姓名
  @Column(name = "create_user_name")
  private String createUserName;

  //创建时间
  @Column(name = "create_date")
  private Date createDate;

  //修改人id
  @Column(name = "update_user_id")
  private Long updateUserId;

  //修改人姓名
  @Column(name = "update_user_name")
  private String updateUserName;

  //更新时间
  @Column(name = "update_date")
  private Date updateDate;

  //varchar预留字段1
  @Column(name = "param1")
  private String param1;

  //预留字段2
  @Column(name = "param2")
  private Long param2;

  //预留字段3
  @Column(name = "param3")
  private BigDecimal param3;


}
